<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateProjectFieldsTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
        Schema::create('project_fields',function(Blueprint $table){
        $table->increments('id');               //项目-行业领域关系表
        $table->unsignedInteger('project_id');  //项目标识
        $table->unsignedInteger('field_id');    //行业领域标识

        $table->softDeletes();
        $table->timestamps();
    });
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('project_fields');
	}

}
